package com.techysky.repository;

import com.techysky.entity.CommentTags;

import java.io.Serializable;
import java.util.List;

import org.springframework.data.jpa.repository.Query;

public interface CommentTagsRepository extends CoreRepository<CommentTags, Serializable> {
	
	@Query(value="select  t.* from  sys_comment_tags  t  where   t.user_name=?1  and type='p' order by t.publish_date desc ", nativeQuery = true)
	List<com.techysky.entity.CommentTags> findAllCommentTags(String userName);
	
}
